﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$SyrinxDBConnection$" >
	<Sql>
		INSERT INTO ObjectTreeCounts
		(objectId, treeName, keyName, name, rootId, depth, totalL1, totalL2, totalL3, totalL4, totalViews, lastViewed, lastChildUpdated, lastChildUpdatedByUserId,
			dateUpdated, dateCreated, authorId)
		VALUES
		(@objectId, @treeName, @keyName, @name, @rootId, @depth, @totalL1, @totalL2, @totalL3, @totalL4, @totalViews, GetDate(), @lastChildUpdated, @luById,
			@dateUpdated, @dateCreated, @authorId)
	</Sql>
	<Param name="objectId" type="Guid"/>
	<Param name="rootId" type="Guid"/>
	<Param name="treeName" type="String"/>
	<Param name="keyName" type="String"/>
	<Param name="name" type="String"/>
	<Param name="depth" type="Int"/>
	
	<Param name="counts.totalL1" dbName="totalL1" type="Int"/>
	<Param name="counts.totalL2" dbName="totalL2" type="Int"/>
	<Param name="counts.totalL3" dbName="totalL3" type="Int"/>
	<Param name="counts.totalL4" dbName="totalL4" type="Int"/>
	<Param name="counts.totalViews" dbName="totalViews" type="Int"/>
	<Param name="counts.lastChildUpdated" dbName="lastChildUpdated" type="Date" />
	<Param name="counts.lastChildUpdatedBy.id" dbName="luById" type="Guid" />
	<Param name="counts.dateUpdated" dbName="dateUpdated" type="Date" />
	<Param name="counts.dateCreated" dbName="dateCreated" type="Date" />
	<Param name="counts.author.id" dbName="authorId" type="Guid" />
</AdoNetDataAccess>